package com.jlkf.dao;

import java.util.List;
import java.util.Map;

import com.jlkf.pojo.TblOrder;

public interface TblOrderMapper {
    int deleteByPrimaryKey(Long gId);

    int insert(TblOrder record);

    int insertSelective(TblOrder record);

    TblOrder selectByPrimaryKey(Long gId);

    int updateByPrimaryKeySelective(TblOrder record);

    int updateByPrimaryKey(TblOrder record);

	List<TblOrder> myCourseInfo(Map<String, Object> map);

    TblOrder getVipInfo(Long userId);
    
    int updateStatus(Map<String, Object> map);
    
    Double getMoneyByUId(Long userId); //用户消费总额
    
    Double getTotalMoney(List<Integer> list); //统计某个上级所拥有的下级消费总额
    
    List<TblOrder> selectByType(Map<String, Object> map); //后台订单管理 
    
    Double selectCourseMoneyByUser(Map<String, Object> map); //根据用户Id查询代理课程消费总额
    
    Double selectCourseIntegralByUser(Map<String, Object> map); //根据用户Id查询代理课程消费积分
    
    Double selectIntegralMoneyByUser(Map<String, Object> map); //根据用户Id查询购买积分消费总额
    
    List<TblOrder> selectVipStatistics(Map<String, Object> map); //会员缴费统计
}